INSERT INTO
[Segment]
(
    [SegmentName]
,   [SortOrdinal]
,   [CreateDate]
,   [ParentSegmentId]
,   [ClientId]
,   [IsActive]
)
VALUES
(
    @SegmentName
,   @SortOrdinal
,   @CreateDate
,   @ParentSegmentId
,   @ClientId
,   @IsActive
);

SELECT NewId = @@IDENTITY;
